<?php

/**
 * @version     CBE UserlisteView default_header.php 2009.07.26
 * @package		CommunityBuilderEnhanced for Joomla 1.6
 * @subpackage 	Komponente
 * @author 		CBE Entwicklerteam
 * @link		http://www.joomla-cbe.de
 * @copyright 	Copyright (C) 2005 - 2009 Open Source Matters, Inc. All rights reserved.
 * @license     GNU/GPL
 */

// No direct access
defined('_JEXEC') or die('Restricted access');
		$query = new JQuery;
		// Select some fields
		$query->select('*');
		// From the hello table
		$query->from('#__cbe as cbe ');
		//$query->from('#__users');
		// Join over the table from cbe and from joomla.
		$query->leftjoin(' #__users AS users ON cbe.id = users.id');
echo $query->__toString();
?>
<tr>
	<th width="5">
		<?php echo JText::_( 'CBE_ID' ); ?>
	</th>
	<th width="20">
		<input type="checkbox" name="toggle" value="" onclick="checkAll(<?php echo count( $this->items ); ?>);" />
	</th>			
	<th>
		<?php echo JText::_( 'CBE_USERNAME' ); ?>
	</th>
	<th>
		<?php echo JText::_( 'CBE_NAME' ); ?>
	</th>
	<th>
		<?php echo JText::_( 'CBE_AVATAR' ); ?>
	</th>

</tr>

